package com.wutianyi.module.member;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.wutianyi.module.member.dataobject.MemberDO;

public interface MemberMapper {
	@Select("select m.id,m.name,password,m.gmt_create gmtCreate,m.gmt_modified gmtModified,c.c_id cId,cy.company_id companyId from member m left join member_to_company c on(m.id = c.m_id) left join company cy on(c.c_id = cy.id)  where m.name=#{name}")
	public MemberDO getMemberByName(@Param("name") String name);
}
